A Logical Approach to Multidimensional Databases
نویسندگان
چکیده
In this paper we present MD, a logical model for OLAP systems, and show how it can be used in the design of multidimensional databases. Unlike other models for multidimensional databases, MD is independent of any speci c implementation (relational or proprietary multidimensional) and as such it provides a clear separation between practical and conceptual aspects. In this framework, we present a design methodology, to obtain an MD scheme from an operational database. We then show how an MD database can be implemented, describing translations into relational tables and into multidimensional arrays.
منابع مشابه
A Logical Framework for Querying
We address the issue of designing e ective query languages for OLAP databases. The basis of our investigation is MD, a logical data model for multidimensional databases that, unlike other multidimensional models, is independent of any speci c implementation. As such, MD provides a clear separation between practical and conceptual aspects of multidimensional analysis. In this framework, we prese...
متن کاملA Logical Framework for QueryingMultidimensional Data
We address the issue of designing eeective query languages for OLAP databases. The basis of our investigation is MD, a logical data model for multidimensional databases that, unlike other multidimensional models, is independent of any speciic implementation. As such, MD provides a clear separation between practical and conceptual aspects of multidimen-sional analysis. In this framework, we pres...
متن کاملDifference Sequence Compression of Multidimensional Databases
The multidimensional databases often use compression techniques in order to decrease the size of the database. This paper introduces a new method called difference sequence compression. Under some conditions, this new technique is able to create a smaller size multidimensional database than others like single count header compression, logical position compression or base-offset compression.
متن کاملAggregate Query Rewriting in Multidimensional Databases
An efficient query engine is certainly one of the most important components in data warehouses (also known as OLAP systems or multidimensional databases) and its efficiency is influenced by many other aspects, both logical (data model, policy of view materialization, etc.) and physical (multidimensional or relational storage, indexes, etc). As is evident, OLAP queries are often based on the usu...
متن کاملQuerying Multidimensional Data
A powerful, easy-to-use querying environment is without doubt one of the most important components in a multidimensional database. Its effectiveness is influenced by many aspects, both logical (data model, integration, policy of view materialization, etc.) and physical (multidimensional or relational storage, indexes, etc.). Multidimensional querying is often based on the core concepts of multi...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1998